import datetime
from applications.extensions import db


class WalmartMsgResult(db.Model):
    __tablename__ = 'walmart_msg_result'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='主键')
    batch_no = db.Column(db.String(32), comment='当前批次号')
    name = db.Column(db.String(255), comment='姓名')
    phone = db.Column(db.String(11), comment='手机号码')
    msg_result = db.Column(db.String(255), comment='短信结果')
    create_id = db.Column(db.Integer, comment='创建人')
    create_at = db.Column(db.DateTime, default=datetime.datetime.now, comment='创建时间')